#!/usr/bin/env bash

PASSWD_DEV="hisense@2023"
HOST_DEV="dev-jucloud1.cauntyvm1sxg.eu-central-1.rds.amazonaws.com"
DOMAIN_ID="16"


for i in `seq 1 16`
do
    mysql -uroot -p$PASSWD_DEV -h$HOST_DEV -e "ALTER TABLE julink_warehouse.${DOMAIN_ID}_julink_warehouse_${i} ADD pem_version INT DEFAULT 0 COMMENT '根证书版本号';"
    mysql -uroot -p$PASSWD_DEV -h$HOST_DEV -e "show create table julink_warehouse.${DOMAIN_ID}_julink_warehouse_${i}" | grep "pem_version"
done